/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50731
 Source Host           : localhost:3306
 Source Schema         : pear

 Target Server Type    : MySQL
 Target Server Version : 50731
 File Encoding         : 65001

 Date: 10/02/2022 20:53:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `content` text,
  `blogid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of article
-- ----------------------------
BEGIN;
INSERT INTO `article` VALUES (1, 1, 'test_title_1', 'test_content_1', 1);
INSERT INTO `article` VALUES (2, 1, 'test_title_2', 'test_content_2', 1);
INSERT INTO `article` VALUES (3, 1, 'test_title_3', 'test_content_3', 2);
INSERT INTO `article` VALUES (4, 1, 'test_title_4', 'test_content_4', 2);
INSERT INTO `article` VALUES (5, 2, 'test_title_5', 'test_content_5', 2);
COMMIT;

-- ----------------------------
-- Table structure for blog
-- ----------------------------
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of blog
-- ----------------------------
BEGIN;
INSERT INTO `blog` VALUES (1, 'xiaoxun_blog');
INSERT INTO `blog` VALUES (2, 'zhang_blog');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` varchar(20) NOT NULL COMMENT '部门名称',
  `parent_id` varchar(20) DEFAULT NULL COMMENT '父级编号',
  `dept_name` varchar(50) DEFAULT NULL COMMENT '部门名称',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `leader` varchar(50) DEFAULT NULL COMMENT '负责人',
  `phone` varchar(20) DEFAULT NULL COMMENT '联系方式',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `status` varchar(1) DEFAULT NULL COMMENT '部门状态',
  `create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(20) DEFAULT NULL COMMENT '修改人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `remark` text COMMENT '备注',
  `address` varchar(255) DEFAULT NULL COMMENT '详细地址',
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES ('1', '0', '济南总公司', 1, '就眠仪式', '15553726531', 'pearadmin@gmail.com', '1', NULL, NULL, NULL, NULL, NULL, '山东济南');
INSERT INTO `sys_dept` VALUES ('10', '8', '设计部', 3, '就眠仪式', '15553726531', 'pearadmin@gmail.com', '1', NULL, NULL, NULL, NULL, NULL, '山东济南');
INSERT INTO `sys_dept` VALUES ('1316361008259792896', '1316360459930042368', '软件部', 1, '就眠仪式', '15553726531', 'pearadmin@gmail.com', '1', NULL, NULL, NULL, NULL, NULL, '山东济南');
INSERT INTO `sys_dept` VALUES ('1316361192645591040', '1316360459930042368', '市场部', 1, '就眠仪式', '15553726531', 'pearadmin@gmail.com', '1', NULL, NULL, NULL, NULL, NULL, '山东济南');
INSERT INTO `sys_dept` VALUES ('1377824449830584320', '3', '财务部', 1, '就眠仪式', '15553726531', '854085467@qq.com', '1', NULL, NULL, NULL, NULL, NULL, '山东济南');
INSERT INTO `sys_dept` VALUES ('1377825171905183744', '8', '财务部', 1, '就眠仪式', '15553726531', '854085467@qq.com', '1', NULL, NULL, NULL, NULL, NULL, '山东济南');
INSERT INTO `sys_dept` VALUES ('3', '1', '杭州分公司', 1, '就眠仪式', '15553726531', 'pearadmin@gmail.com', '1', NULL, NULL, NULL, NULL, NULL, '浙江杭州');
INSERT INTO `sys_dept` VALUES ('4', '2', '软件部', 2, '就眠仪式', '15553726531', 'pearadmin@gmail.com', '1', NULL, NULL, NULL, NULL, NULL, '山东济南');
INSERT INTO `sys_dept` VALUES ('5', '2', '市场部', 2, '就眠仪式', '15553726531', 'pearadmin@gmail.com', '1', NULL, NULL, NULL, NULL, NULL, '山东济南');
INSERT INTO `sys_dept` VALUES ('6', '3', '软件部', 3, '就眠仪式', '15553726531', 'pearadmin@gmail.com', '1', NULL, NULL, NULL, NULL, NULL, '浙江杭州');
INSERT INTO `sys_dept` VALUES ('7', '3', '设计部', 4, '就眠仪式', '15553726531', 'pearadmin@gmail.com', '1', NULL, NULL, NULL, NULL, NULL, '山东济南');
INSERT INTO `sys_dept` VALUES ('8', '1', '深圳分公司', 3, '就眠仪式', '15553726531', 'pearadmin@gmail.com', '1', NULL, NULL, NULL, NULL, NULL, '山东济南');
INSERT INTO `sys_dept` VALUES ('9', '8', '软件部', 3, '就眠仪式', '15553726531', 'pearadmin@gmail.com', '1', NULL, NULL, NULL, NULL, NULL, '山东济南');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
  `data_id` varchar(32) NOT NULL COMMENT '标识',
  `data_label` char(19) DEFAULT NULL COMMENT '字典标签',
  `data_value` char(20) DEFAULT NULL COMMENT '字典值',
  `type_code` char(20) DEFAULT NULL COMMENT '所属类型',
  `is_default` char(1) DEFAULT NULL COMMENT '是否默认',
  `update_by` char(19) DEFAULT NULL COMMENT '修改人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `enable` char(1) DEFAULT NULL COMMENT '是否启用',
  `status` char(1) DEFAULT '1' COMMENT '状态:1-启用；0-删除',
  PRIMARY KEY (`data_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_data` VALUES ('1', '男', '0', 'system_user_sex', '0', NULL, NULL, NULL, NULL, '描述', '0', '1');
INSERT INTO `sys_dict_data` VALUES ('1302833449496739840', '字典名称', '字典值', 'dict_code', '1', NULL, NULL, NULL, NULL, 'aw', '1', '1');
INSERT INTO `sys_dict_data` VALUES ('1317401149287956480', '男', 'boy', 'user_sex', NULL, NULL, NULL, NULL, NULL, '男 : body', '1', '1');
INSERT INTO `sys_dict_data` VALUES ('1317402976670711808', '女', 'girl', 'user_sex', NULL, NULL, NULL, NULL, NULL, '女 : girl', '1', '1');
INSERT INTO `sys_dict_data` VALUES ('1370411072367886336', '公告', 'public', 'sys_notice_type', NULL, NULL, NULL, NULL, NULL, '公告', '1', '1');
INSERT INTO `sys_dict_data` VALUES ('1370411179544936448', '私信', 'private', 'sys_notice_type', NULL, NULL, NULL, NULL, NULL, '私信', '1', '1');
INSERT INTO `sys_dict_data` VALUES ('1387076909438861312', '短信', 'smmm', 'sys_notice_type', NULL, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_dict_data` VALUES ('2', '女', '1', 'system_user_sex', '1', NULL, NULL, NULL, NULL, '描述', '1', '1');
INSERT INTO `sys_dict_data` VALUES ('447572898392182784', 'awd', 'awd', 'dict_code', '1', NULL, NULL, NULL, NULL, 'awd', '1', '1');
INSERT INTO `sys_dict_data` VALUES ('62036af34cea3c62f2f1fde8', 'we', 'girl3', 'user_sex', NULL, NULL, NULL, 'admin', '2022-02-09 15:19:15', '333', '1', '0');
INSERT INTO `sys_dict_data` VALUES ('62036af34cea3c62f2f1fde9', 'we', 'girl3', 'user_sex', NULL, NULL, NULL, 'admin', '2022-02-09 15:19:15', '333', '1', '0');
INSERT INTO `sys_dict_data` VALUES ('62036af34cea3c62f2f1fdea', 'we', 'girl3', 'user_sex', NULL, NULL, NULL, 'admin', '2022-02-09 15:19:15', '333', '1', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
  `id` varchar(32) NOT NULL COMMENT '标识',
  `type_name` varchar(255) DEFAULT NULL COMMENT '字典类型名称',
  `type_code` varchar(255) DEFAULT NULL COMMENT '字典类型标识',
  `description` varchar(255) DEFAULT NULL COMMENT '字典类型描述',
  `enable` char(1) DEFAULT NULL COMMENT '是否启用',
  `create_by` char(19) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` char(19) DEFAULT NULL COMMENT '修改人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` char(1) DEFAULT '1' COMMENT '状态；1-有效,0-删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_type` VALUES ('1317360314219495424', '登录类型', 'sys_notice_type', '登录类型', '1', NULL, '2022-02-09 10:01:50', 'admin', '2022-02-09 11:24:02', NULL, '1');
INSERT INTO `sys_dict_type` VALUES ('1317400519127334912', '用户类型', 'user_status', '用户类型', '1', NULL, '2022-02-09 10:01:53', NULL, NULL, NULL, '1');
INSERT INTO `sys_dict_type` VALUES ('1317400823096934400', '配置类型', 'config_type', '配置类型', '1', NULL, '2022-02-09 10:01:57', NULL, NULL, NULL, '1');
INSERT INTO `sys_dict_type` VALUES ('1370410853110644736', '消息类型', 'sys_notice_type', '消息类型', '1', NULL, '2022-02-09 10:02:00', NULL, NULL, NULL, '1');
INSERT INTO `sys_dict_type` VALUES ('455184568505470976', '用户性别', 'user_sex', '用户性别', '1', NULL, '2022-02-09 10:02:03', NULL, NULL, NULL, '1');
INSERT INTO `sys_dict_type` VALUES ('455184935989415936', '全局状态', 'sys_status', '状态描述\n', '1', NULL, '2022-02-09 10:02:06', NULL, NULL, NULL, '1');
INSERT INTO `sys_dict_type` VALUES ('620331284cea385775052cfa', '订单状态', 'order_status', '333', '1', 'admin', '2022-02-09 11:12:40', NULL, NULL, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file` (
  `id` varchar(255) NOT NULL COMMENT '标识',
  `file_name` varchar(255) DEFAULT NULL COMMENT '文件名称',
  `file_desc` varchar(255) DEFAULT NULL COMMENT '文件描述',
  `file_path` varchar(255) DEFAULT NULL COMMENT '文件路径',
  `file_type` varchar(255) DEFAULT NULL COMMENT '文件类型',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '修改人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `target_date` datetime DEFAULT NULL COMMENT '所属时间',
  `file_size` varchar(255) DEFAULT NULL COMMENT '文件大小',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_logging
-- ----------------------------
DROP TABLE IF EXISTS `sys_logging`;
CREATE TABLE `sys_logging` (
  `id` char(19) NOT NULL COMMENT '相应消息体',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `method` varchar(255) DEFAULT NULL COMMENT '请求方式',
  `business_type` varchar(255) DEFAULT NULL COMMENT '业务类型',
  `request_method` varchar(255) DEFAULT NULL COMMENT '请求方法',
  `operate_name` varchar(255) DEFAULT NULL COMMENT '操作人',
  `operate_url` varchar(255) DEFAULT NULL COMMENT '操作路径',
  `operate_address` varchar(255) DEFAULT NULL COMMENT '操作地址',
  `request_param` varchar(255) DEFAULT NULL COMMENT '请求参数',
  `response_body` varchar(255) DEFAULT NULL COMMENT '相应消息体',
  `success` varchar(255) DEFAULT NULL COMMENT '是否成功',
  `error_msg` text COMMENT '异常信息',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `request_body` varchar(255) DEFAULT NULL COMMENT '请求消息体',
  `browser` varchar(255) DEFAULT NULL COMMENT '使用浏览器',
  `system_os` varchar(255) DEFAULT NULL COMMENT '操作系统',
  `logging_type` varchar(10) DEFAULT NULL COMMENT '日志类型，登录日志，操作日志',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_logging
-- ----------------------------
BEGIN;
INSERT INTO `sys_logging` VALUES ('1387093346635218944', '登录', '/login', 'OTHER', 'POST', 'admin', '/login', '127.0.0.1', NULL, NULL, '1', NULL, '2021-04-28 01:16:39', '登录成功', NULL, '谷歌浏览器', 'Windows', 'LOGIN');
INSERT INTO `sys_logging` VALUES ('1387093352247197696', '主页', '/index', 'ADD', 'GET', 'admin', '/index', '127.0.0.1', NULL, NULL, '1', NULL, '2021-04-28 01:16:41', '返回 Index 主页视图', NULL, '谷歌浏览器', 'Windows', 'OPERATE');
INSERT INTO `sys_logging` VALUES ('1387093362711986176', '查询用户', '/system/user/data', 'QUERY', 'GET', 'admin', '/system/user/data', '127.0.0.1', NULL, NULL, '1', NULL, '2021-04-28 01:16:43', '查询用户', 'page=1&limit=10', '谷歌浏览器', 'Windows', 'OPERATE');
COMMIT;

-- ----------------------------
-- Table structure for sys_mail
-- ----------------------------
DROP TABLE IF EXISTS `sys_mail`;
CREATE TABLE `sys_mail` (
  `mail_id` varchar(20) NOT NULL COMMENT '邮件id(主键)',
  `receiver` varchar(1024) NOT NULL DEFAULT '0' COMMENT '收件人邮箱',
  `subject` varchar(128) DEFAULT NULL COMMENT '邮件主体',
  `content` text NOT NULL COMMENT '邮件正文',
  `create_by` varchar(16) DEFAULT NULL COMMENT '发送人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`mail_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_mail
-- ----------------------------
BEGIN;
INSERT INTO `sys_mail` VALUES ('1349598576807772160', '1218600762@qq.com', 'macbook pro', '13.3寸\nm1处理器\n16G内存', 'admin', '2021-01-14 06:06:23');
INSERT INTO `sys_mail` VALUES ('1357215518368464896', 'BoscoKuo@aliyun.com', '湖人总冠军', '湖人总冠军', 'admin', '2021-02-04 06:33:36');
INSERT INTO `sys_mail` VALUES ('1357219037586653184', 'BoscoKuo@aliyun.com', 'LebronJames', 'Lakers', 'admin', '2021-02-04 06:47:35');
COMMIT;

-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE `sys_notice` (
  `id` char(20) NOT NULL COMMENT '编号',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `content` text COMMENT '内容',
  `sender` char(20) DEFAULT NULL COMMENT '发送人',
  `accept` char(20) DEFAULT NULL COMMENT '接收者',
  `type` char(10) DEFAULT NULL COMMENT '类型',
  `create_by` char(20) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` char(20) DEFAULT NULL COMMENT '修改人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_notice
-- ----------------------------
BEGIN;
INSERT INTO `sys_notice` VALUES ('1370769290961092608', '公告测试', '公告测试', '1309861917694623744', NULL, 'public', NULL, '2021-03-14 00:10:41', NULL, NULL, NULL);
INSERT INTO `sys_notice` VALUES ('1370769348204953600', '私信测试', '私信测试', '1309861917694623744', '1310409555649232897', 'private', NULL, '2021-03-14 00:10:55', NULL, NULL, NULL);
INSERT INTO `sys_notice` VALUES ('1370771980034244608', '公告测试', '公告测试', '1309861917694623744', NULL, 'public', NULL, '2021-03-14 00:21:22', NULL, NULL, NULL);
INSERT INTO `sys_notice` VALUES ('1370772014771470336', '公告测试', '公告测试', '1309861917694623744', NULL, 'public', NULL, '2021-03-14 00:21:31', NULL, NULL, NULL);
INSERT INTO `sys_notice` VALUES ('1370772050439831552', '公告测试', '公告测试', '1309861917694623744', NULL, 'public', NULL, '2021-03-14 00:21:39', NULL, NULL, NULL);
INSERT INTO `sys_notice` VALUES ('1370772089446858752', '私信测试', '私信测试', '1309861917694623744', '1310409555649232897', 'private', NULL, '2021-03-14 00:21:48', NULL, NULL, NULL);
INSERT INTO `sys_notice` VALUES ('1370772143918284800', '私信测试', '私信测试', '1309861917694623744', '1310409555649232897', 'private', NULL, '2021-03-14 00:22:01', NULL, NULL, NULL);
INSERT INTO `sys_notice` VALUES ('1370772363838226432', '私信测试', '私信测试', '1309861917694623744', '1349021166525743105', 'private', NULL, '2021-03-14 00:22:54', NULL, NULL, NULL);
INSERT INTO `sys_notice` VALUES ('1370772466212798464', '私信测试', '私信测试', '1309861917694623744', '1349021166525743105', 'private', NULL, '2021-03-14 00:23:18', NULL, NULL, NULL);
INSERT INTO `sys_notice` VALUES ('1370971086266564608', '私信测试', '私信测试', '1309861917694623744', '1309861917694623744', 'private', NULL, '2021-03-14 13:32:33', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_power
-- ----------------------------
DROP TABLE IF EXISTS `sys_power`;
CREATE TABLE `sys_power` (
  `power_id` varchar(32) NOT NULL COMMENT '权限编号',
  `power_name` varchar(255) DEFAULT NULL COMMENT '权限名称',
  `power_type` char(1) DEFAULT NULL COMMENT '权限类型',
  `power_code` char(30) DEFAULT NULL COMMENT '权限标识',
  `power_url` varchar(255) DEFAULT NULL COMMENT '权限路径',
  `open_type` char(10) DEFAULT NULL COMMENT '打开方式',
  `parent_id` varchar(32) DEFAULT NULL COMMENT '父类编号',
  `icon` varchar(128) DEFAULT NULL COMMENT '图标',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `create_by` char(19) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` char(19) DEFAULT NULL COMMENT '修改人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `enable` char(1) DEFAULT NULL COMMENT '是否开启',
  `status` char(1) DEFAULT '1' COMMENT '状态：1-有效；0-删除',
  PRIMARY KEY (`power_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_power
-- ----------------------------
BEGIN;
INSERT INTO `sys_power` VALUES ('1', '系统管理', '0', '', '', NULL, '0', 'layui-icon layui-icon-set-fill', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1284020948269268992', '用户列表', '2', 'sys:user:data', '', '', '2', 'layui-icon-username', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1284022967767924736', '用户保存', '2', 'sys:user:add', '', '', '2', 'layui-icon-username', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1302180351979814912', '布局构建', '1', 'generator:from:main', 'component/code/index.html', '_iframe', '442417411065516032', 'layui-icon-senior', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1304387665067507712', '数据字典', '1', 'sys:dictType:main', '/dict-view', '_iframe', '1', 'layui-icon layui-icon layui-icon layui-icon layui-icon-flag', 4, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1305870685385523200', '百度一下', '1', '', 'http://www.baidu.com', '0', '474356044148117504', 'layui-icon-search', 2, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1305875436139446272', '百度一下', '1', 'http://www.baidu.com', 'http://www.baidu.com', '0', '451002662209589248', 'layui-icon-search', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310206853057085440', '用户修改', '2', 'sys:user:edit', '', '', '2', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310208636370288640', '用户删除', '2', 'sys:user:remove', '', '', '2', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310209696916832256', '角色新增', '2', 'sys:role:add', '', '', '3', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310209900478988288', '角色删除', '2', 'sys:role:remove', '', '', '3', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310210054728712192', '角色修改', '2', 'sys:role:edit', '', '', '3', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310211965188046848', '角色授权', '2', 'sys:role:power', '', '', '3', 'layui-icon-vercode', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310226416867999744', '权限列表', '2', 'sys:power:data', '', '', '4', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310226976593674240', '权限新增', '2', 'sys:power:add', '', '', '4', 'layui-icon-vercode', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310227130998587392', '权限修改', '2', 'sys:power:edit', '', '', '4', 'layui-icon-vercode', 2, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310227300935008256', '权限删除', '2', 'sys:power:remove', '', '', '4', 'layui-icon-vercode', 3, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310232350285627392', '操作日志', '2', 'sys:log:operateLog', '', '', '450300705362808832', 'layui-icon layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310232462562951168', '登录日志', '2', 'sys:log:loginLog', '', '', '450300705362808832', 'layui-icon layui-icon-vercode', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310238229588344832', '配置列表', '2', 'sys:config:data', '', '', '1307299332784914432', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '0', '1');
INSERT INTO `sys_power` VALUES ('1310238417082122240', '配置新增', '2', 'sys:config:add', '', '', '1307299332784914432', 'layui-icon-vercode', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310238574355939328', '配置修改', '2', 'sys:config:edit', '', '', '1307299332784914432', 'layui-icon-vercode', 2, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310238700705153024', '配置删除', '2', 'sys:config:remove', '', '', '1307299332784914432', 'layui-icon-vercode', 3, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310243862937075712', '文件列表', '2', 'sys:file:data', '', '', '1304793451996381184', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310244103824343040', '文件新增', '2', 'sys:file:add', '', '', '1304793451996381184', 'layui-icon-vercode', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310244248884346880', '文件删除', '2', 'sys:file:remove', '', '', '1304793451996381184', 'layui-icon-vercode', 3, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310390699333517312', '任务列表', '2', 'sch:job:data', '', '', '442650770626711552', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310390994826428416', '任务新增', '2', 'sch:job:add', '', '', '442650770626711552', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310391095670079488', '任务修改', '2', 'sch:job:edit', '', '', '442650770626711552', 'layui-icon-vercode', 2, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310391707069579264', '任务删除', '2', 'sch:job:remove', '', '', '442650770626711552', 'layui-icon-vercode', 3, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310395250908332032', '日志列表', '2', 'sch:log:data', '', '', '442651158935375872', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310397832091402240', '任务恢复', '2', 'sch:job:resume', '', '', '442650770626711552', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310398020692475904', '任务停止', '2', 'sch:job:pause', '', '', '442650770626711552', 'layui-icon-vercode', 3, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310398158974484480', '任务运行', '2', 'sch:job:run', '', '', '442650770626711552', 'layui-icon-vercode', 4, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310402491631796224', '数据类型列表', '2', 'sys:dictType:data', '', '', '1304387665067507712', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310402688881524736', '数据类型新增', '2', 'sys:dictType:add', '', '', '1304387665067507712', 'layui-icon-vercode', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310402817776680960', '数据类型修改', '2', 'sys:dictType:edit', '', '', '1304387665067507712', 'layui-icon-vercode', 3, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310403004406431744', '数据类型删除', '2', 'sys:dictType:remove', '', '', '1304387665067507712', 'layui-icon-vercode', 3, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310404584291696640', '数据字典视图', '2', 'sys:dictData:main', '', '', '1304387665067507712', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310404705934901248', '数据字典列表', '2', 'sys:dictData:data', '', '', '1304387665067507712', 'layui-icon-vercode', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310404831407505408', '数据字典新增', '2', 'sys:dictData:add', '', '', '1304387665067507712', 'layui-icon-vercode', 5, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310404999599095808', '数据字典删除', '2', 'sys:dictData:remove', '', '', '1304387665067507712', 'layui-icon-vercode', 6, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1310405161587310592', '数据字典修改', '2', 'sys:dictData:edit', '', '', '1304387665067507712', 'layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1313142510486290432', '公告列表', '1', 'sys:notice:data', '/system/notice/data', '0', '1313142171393589248', 'layui-icon-notice', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1313482983558086656', '公告新增', '2', 'sys:notice:add', '', '', '1313142171393589248', 'layui-icon-vercode', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1313483090852577280', '公告修改', '2', 'sys:notice:edit', '', '', '1313142171393589248', 'layui-icon-vercode', 2, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1313483189850734592', '公告删除', '2', 'sys:notice:remove', '', '', '1313142171393589248', 'layui-icon-vercode', 3, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1315584471046553600', '部门管理', '1', 'sys:dept:main', '/deptment-view', '_iframe', '1', 'layui-icon layui-icon layui-icon layui-icon-vercode', 3, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1316558444790022144', '部门新增', '2', 'sys:dept:add', '', '', '1315584471046553600', 'layui-icon layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1316558556102656000', '部门修改', '2', 'sys:dept:edit', '', '', '1315584471046553600', 'layui-icon layui-icon-vercode', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1316558685442408448', '部门删除', '2', 'sys:dept:remove', '', '', '1315584471046553600', 'layui-icon layui-icon-vercode', 3, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1317555660455411712', '部门列表', '2', 'sys:dept:data', '', '', '1315584471046553600', 'layui-icon layui-icon layui-icon layui-icon-vercode', 2, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1318229908526202880', '模型新增', '2', 'pro:model:add', '', '', '1307562519451140096', 'layui-icon layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1318230013262168064', '模型修改', '2', 'pro:model:edit', '', '', '1307562519451140096', 'layui-icon layui-icon-vercode', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1318230265385975808', '模型删除', '2', 'pro:model:remove', '', '', '1307562519451140096', 'layui-icon layui-icon-vercode', 2, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1320969572051845120', '111111', '2', '', '', '', '1284020948269268992', 'layui-icon-login-qq', 0, NULL, NULL, NULL, NULL, NULL, NULL, '1');
INSERT INTO `sys_power` VALUES ('1322085079861690368', '用户管理', '1', 'sys:user:main', '/user-index', '_iframe', '1', 'layui-icon layui-icon-face-smile', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1322085270392143872', '用户列表', '2', 'sys:user:query', '', '', '1322085079861690368', 'layui-icon layui-icon layui-icon layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1322085393021009920', '用户新增', '2', 'sys:user:add', '', '', '1322085079861690368', 'layui-icon layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1322085497798918144', '用户修改', '2', 'sys:user:edit', '', '', '1322085079861690368', 'layui-icon layui-icon layui-icon-vercode', 2, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1322085659766161408', '用户删除', '2', 'sys:user:remove', '', '', '1322085079861690368', 'layui-icon layui-icon-rate', 3, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1329349076189184000', '', '1', '', '', '', '451002662209589248', 'layui-icon', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1348562759603716096', '在线列表', '1', 'sys:online:data', '/system/online/data', '_iframe', '1330865171429588992', 'layui-icon layui-icon-username', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1349636574442160128', '邮件发送', '2', 'sys:mail:save', '', '', '1349279791521464320', 'layui-icon layui-icon layui-icon layui-icon layui-icon layui-icon-vercode', 3, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1349636919478190080', '邮件删除', '2', 'sys:mail:remove', '', '', '1349279791521464320', 'layui-icon layui-icon layui-icon layui-icon layui-icon-vercode', 2, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1349637786285637632', '邮件列表', '2', 'sys:mail:data', '', '', '1349279791521464320', 'layui-icon layui-icon layui-icon-vercode', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1349638479767666688', '邮件新增', '2', 'sys:mail:add', '', '', '1349279791521464320', 'layui-icon layui-icon layui-icon-vercode', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1370412169610395649', '消息列表', '2', 'system:notice:data', '', NULL, '1370412169610395648', 'layui-icon layui-icon-set-fill', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1370412169610395650', '消息新增', '2', 'system:notice:add', '', NULL, '1370412169610395648', 'layui-icon layui-icon-set-fill', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1370412169610395651', '消息修改', '2', 'system:notice:edit', '', NULL, '1370412169610395648', 'layui-icon layui-icon-set-fill', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1370412169610395652', '消息删除', '2', 'system:notice:remove', '', NULL, '1370412169610395648', 'layui-icon layui-icon-set-fill', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('1370974716822552576', '修改设置', '2', 'sys:setup:add', '', '', '1355962888132493312', 'layui-icon layui-icon-vercode', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('2', '用户管理', '2', '', '', '_iframe', '1320969572051845120', 'layui-icon layui-icon layui-icon-username', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('3', '角色管理', '1', 'sys:role:main', '/role-index', '_iframe', '1', 'layui-icon layui-icon-user', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('4', '权限管理', '1', 'sys:power:main', '/permission-index', '_iframe', '1', 'layui-icon layui-icon-vercode', 2, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('442359447487123456', '角色列表', '2', 'sys:role:data', '', '', '3', 'layui-icon layui-icon-rate', 1, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('442417411065516032', '开发工具', '0', '', '', '', '0', 'layui-icon layui-icon layui-icon-senior', 2, NULL, NULL, 'admin', '2022-02-08 14:40:29', NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('451002662209589248', '工作空间', '1', '', '', '', '451002662209589248', 'layui-icon layui-icon layui-icon-home', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('451003242072117248', '项目总览', '1', 'process:model:main', '/console', '_iframe', '451002662209589248', 'layui-icon  layui-icon-component', 0, NULL, NULL, NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('474356363552755712', '项目介绍', '1', 'home', '/console', '_iframe', '474356044148117504', 'layui-icon layui-icon-home', 1, NULL, NULL, NULL, NULL, NULL, '0', '1');
INSERT INTO `sys_power` VALUES ('62036dca4cea3c62f2f1fdeb', '数据图表', '0', '', '', '_iframe', '0', 'layui-icon layui-icon-chart', 5, 'admin', '2022-02-09 15:31:22', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('62036e2b4cea3c62f2f1fdf3', '折线图', '1', '', 'view/echarts/line.html', '_iframe', '62036dca4cea3c62f2f1fdeb', 'layui-icon layui-icon-face-smile', 1, 'admin', '2022-02-09 15:32:59', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('62036e554cea3c62f2f1fdf4', '柱状图', '1', '', 'view/echarts/column.html', '_iframe', '62036dca4cea3c62f2f1fdeb', 'layui-icon layui-icon-face-smile', 2, 'admin', '2022-02-09 15:33:41', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('620370804cea44ea3ed88c9f', '常用组件', '0', '', '', '_iframe', '0', 'layui-icon layui-icon-component', 6, 'admin', '2022-02-09 15:42:57', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('620374ab4cea44ea3ed88ca0', '进阶组件', '0', '', '', '_iframe', '620370804cea44ea3ed88c9f', 'layui-icon layui-icon-console', 1, 'admin', '2022-02-09 16:00:43', 'admin', '2022-02-09 16:03:40', NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('620376854cea44ea3ed88ca1', '数据表格', '1', '', 'view/document/table.html', '_iframe', '620374ab4cea44ea3ed88ca0', 'layui-icon layui-icon-face-cry', 1, 'admin', '2022-02-09 16:08:38', 'admin', '2022-02-09 16:08:54', NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('620376c54cea44ea3ed88ca2', '分布表单', '1', '', 'view/document/step.html', '_iframe', '620374ab4cea44ea3ed88ca0', 'layui-icon layui-icon-face-cry', 2, 'admin', '2022-02-09 16:09:41', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('620376e94cea44ea3ed88ca3', '树形表格', '1', '', 'view/document/treetable.html', '_iframe', '620374ab4cea44ea3ed88ca0', 'layui-icon layui-icon-face-cry', 3, 'admin', '2022-02-09 16:10:17', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('620377364cea44ea3ed88ca4', '树状结构', '1', '', 'view/document/dtree.html', '_iframe', '620374ab4cea44ea3ed88ca0', 'layui-icon layui-icon-face-cry', 4, 'admin', '2022-02-09 16:11:34', 'admin', '2022-02-09 16:11:48', NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('620377654cea44ea3ed88ca5', '文本编辑', '1', '', 'view/document/tinymce.html', '_iframe', '620374ab4cea44ea3ed88ca0', 'layui-icon layui-icon-face-cry', 5, 'admin', '2022-02-09 16:12:21', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('620377864cea44ea3ed88ca6', '卡片组件', '1', '', 'view/document/card.html', '_iframe', '620374ab4cea44ea3ed88ca0', 'layui-icon layui-icon-face-cry', 6, 'admin', '2022-02-09 16:12:55', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('620379514cea44ea3ed88ca7', '弹层组件', '0', '', '', '_iframe', '620370804cea44ea3ed88c9f', 'layui-icon layui-icon-console', 2, 'admin', '2022-02-09 16:20:34', 'admin', '2022-02-09 16:20:53', NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('620379ad4cea44ea3ed88ca8', '抽屉组件', '1', '', 'view/document/drawer.html', '_iframe', '620379514cea44ea3ed88ca7', 'layui-icon layui-icon-face-cry', 1, 'admin', '2022-02-09 16:22:06', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('620379ce4cea44ea3ed88ca9', '消息通知', '1', '', 'view/document/notice.html', '_iframe', '620379514cea44ea3ed88ca7', 'layui-icon layui-icon-face-cry', 2, 'admin', '2022-02-09 16:22:39', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('620379f04cea44ea3ed88caa', '加载组件', '1', '', 'view/document/loading.html', '_iframe', '620379514cea44ea3ed88ca7', 'layui-icon layui-icon-face-cry', 3, 'admin', '2022-02-09 16:23:13', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('62037a0d4cea44ea3ed88cab', '弹层组件', '1', '', 'view/document/popup.html', '_iframe', '620379514cea44ea3ed88ca7', 'layui-icon layui-icon-face-cry', 4, 'admin', '2022-02-09 16:23:41', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('62037a2b4cea44ea3ed88cac', '高级组件', '0', '', '', '_iframe', '620370804cea44ea3ed88c9f', 'layui-icon layui-icon-console', 3, 'admin', '2022-02-09 16:24:12', 'admin', '2022-02-09 16:24:26', NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('62037a5b4cea44ea3ed88cad', '多选项卡', '1', '', 'view/document/tab.html', '_iframe', '62037a2b4cea44ea3ed88cac', 'layui-icon layui-icon-face-cry', 1, 'admin', '2022-02-09 16:25:00', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('62037a764cea44ea3ed88cae', '数据菜单', '1', '', 'view/document/menu.html', '_iframe', '62037a2b4cea44ea3ed88cac', 'layui-icon layui-icon-face-cry', 2, 'admin', '2022-02-09 16:25:27', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('62037a994cea44ea3ed88caf', '其他组件', '0', '', '', '_iframe', '620370804cea44ea3ed88c9f', 'layui-icon layui-icon-console', 4, 'admin', '2022-02-09 16:26:01', 'admin', '2022-02-09 16:26:13', NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('62037bcd4cea44ea3ed88cb0', '哈希加密', '1', '', 'view/document/hash.html', '_iframe', '62037a994cea44ea3ed88caf', 'layui-icon layui-icon-face-cry', 1, 'admin', '2022-02-09 16:31:10', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('62037bec4cea44ea3ed88cb1', '图标选择', '1', '', 'view/document/iconPicker.html', '_iframe', '62037a994cea44ea3ed88caf', 'layui-icon layui-icon-face-cry', 2, 'admin', '2022-02-09 16:31:40', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('62037c064cea44ea3ed88cb2', '省市级联', '1', '', 'view/document/area.html', '_iframe', '62037a994cea44ea3ed88caf', 'layui-icon layui-icon-face-cry', 3, 'admin', '2022-02-09 16:32:07', 'admin', '2022-02-09 16:32:56', NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('62037c294cea44ea3ed88cb3', '数字滚动', '1', '', 'view/document/count.html', '_iframe', '62037a994cea44ea3ed88caf', 'layui-icon layui-icon-face-cry', 4, 'admin', '2022-02-09 16:32:42', NULL, NULL, NULL, '1', '1');
INSERT INTO `sys_power` VALUES ('62037c634cea44ea3ed88cb4', '顶部返回', '1', '', 'view/document/topBar.html', '_iframe', '62037a994cea44ea3ed88caf', 'layui-icon layui-icon-face-cry', 5, 'admin', '2022-02-09 16:33:40', NULL, NULL, NULL, '1', '1');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` varchar(32) NOT NULL COMMENT '角色编号',
  `role_name` varchar(255) DEFAULT NULL COMMENT '角色名称',
  `role_code` varchar(255) DEFAULT NULL COMMENT '角色标识',
  `enable` char(1) DEFAULT NULL COMMENT '是否启用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` char(19) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` char(19) DEFAULT NULL COMMENT '修改人',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `details` varchar(255) DEFAULT NULL COMMENT '详情',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `status` char(1) DEFAULT '1' COMMENT '状态：1-有效 0-删除',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('1309851245195821056', '超级管理员', 'admin', '1', '2022-02-01 20:13:28', NULL, NULL, NULL, NULL, '超级管理员', 1, '1');
INSERT INTO `sys_role` VALUES ('1313761100243664896', '普通管理员', 'manager', '1', '2022-02-01 20:13:32', NULL, NULL, NULL, NULL, '普通管理员', 2, '1');
INSERT INTO `sys_role` VALUES ('1356112133691015168', '应急管理员', 'users', '1', '2022-02-01 20:13:38', NULL, '2022-02-02 18:59:59', 'admin', NULL, '应急管理员', 2, '1');
INSERT INTO `sys_role` VALUES ('61f93d594cea6c0000a1ca20', '运营专员', 'operationStaff', '1', '2022-02-01 22:10:54', NULL, NULL, NULL, NULL, '普通运营专员角色', NULL, '1');
INSERT INTO `sys_role` VALUES ('61f93f1d4ceac72aaa27319c', '运营经理', 'operationManager', '1', '2022-02-01 22:09:33', 'admin', NULL, NULL, NULL, '运营经理角色', NULL, '1');
INSERT INTO `sys_role` VALUES ('61fa649395480e768780563c', '运营实习生', 'operationNovice', '1', '2022-02-02 19:01:40', 'admin', NULL, NULL, NULL, '运营实习生角色', NULL, '1');
INSERT INTO `sys_role` VALUES ('61fa64d895480e768780563d', '财务专员', 'financeStaff', '1', '2022-02-02 19:02:49', 'admin', NULL, NULL, NULL, '财务专员', NULL, '1');
INSERT INTO `sys_role` VALUES ('61fa64f695480e768780563e', '财务经理', 'financeManager', '1', '2022-02-02 19:03:18', 'admin', NULL, NULL, NULL, '财务经理', NULL, '1');
INSERT INTO `sys_role` VALUES ('61fa652e95480e768780563f', '财务实习生', 'financeNovice', '1', '2022-02-02 19:04:14', 'admin', NULL, NULL, NULL, '财务实习生', NULL, '1');
INSERT INTO `sys_role` VALUES ('61fa655795480e7687805640', '信息部主管', 'ITManager', '1', '2022-02-02 19:04:56', 'admin', NULL, NULL, NULL, '信息部主管', NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_power
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_power`;
CREATE TABLE `sys_role_power` (
  `id` varchar(32) NOT NULL,
  `role_id` varchar(32) DEFAULT NULL,
  `power_id` varchar(32) DEFAULT NULL,
  `create_by` char(19) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` char(19) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_role_power
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_power` VALUES ('1284022485632679936', '3', '474356044148117504', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679937', '3', '474356363552755712', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679938', '3', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679939', '3', '3', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679940', '3', '442359447487123456', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679941', '3', '4', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679942', '3', '442722702474743808', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679943', '3', '2', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679944', '3', '1284020948269268992', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679945', '3', '442417411065516032', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679946', '3', '442418188639145984', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679947', '3', '694203021537574912', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679948', '3', '450300705362808832', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679949', '3', '442520236248403968', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679950', '3', '694203311615639552', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679951', '3', '442650387514789888', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679952', '3', '442650770626711552', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679953', '3', '442651158935375872', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679954', '3', '451002662209589248', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1284022485632679955', '3', '451003242072117248', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650364506112', '2', '474356044148117504', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700416', '2', '474356363552755712', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700417', '2', '2', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700418', '2', '1284020948269268992', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700419', '2', '450300705362808832', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700420', '2', '442417411065516032', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700421', '2', '442418188639145984', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700422', '2', '694203021537574912', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700423', '2', '442520236248403968', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700424', '2', '694203311615639552', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700425', '2', '442650387514789888', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700426', '2', '442650770626711552', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700427', '2', '442651158935375872', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700428', '2', '451002662209589248', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1305379650368700429', '2', '451003242072117248', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380352', '1', '451002662209589248', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380353', '1', '451003242072117248', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380354', '1', '1305875436139446272', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380355', '1', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380356', '1', '2', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380357', '1', '1284020948269268992', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380358', '1', '1284022967767924736', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380359', '1', '3', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380360', '1', '442359447487123456', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380361', '1', '4', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380362', '1', '1304387665067507712', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380363', '1', '450300705362808832', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380364', '1', '1304793451996381184', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380365', '1', '1307299332784914432', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380366', '1', '442650387514789888', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380367', '1', '442650770626711552', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380368', '1', '442651158935375872', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380369', '1', '694203021537574912', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380370', '1', '442520236248403968', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380371', '1', '694203311615639552', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380372', '1', '442417411065516032', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380373', '1', '442418188639145984', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380374', '1', '1302180351979814912', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380375', '1', '1307562196556840960', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380376', '1', '1307562519451140096', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1308571532737380377', '1', '1308571483794046976', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897792', '1310215420371795968', '451002662209589248', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897793', '1310215420371795968', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897794', '1310215420371795968', '2', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897795', '1310215420371795968', '3', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897796', '1310215420371795968', '4', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897797', '1310215420371795968', '1304387665067507712', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897798', '1310215420371795968', '450300705362808832', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897799', '1310215420371795968', '1304793451996381184', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897800', '1310215420371795968', '1307299332784914432', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897801', '1310215420371795968', '1313142171393589248', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897802', '1310215420371795968', '1313142510486290432', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897803', '1310215420371795968', '442650387514789888', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897804', '1310215420371795968', '694203021537574912', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897805', '1310215420371795968', '442417411065516032', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1313147486356897806', '1310215420371795968', '1307562196556840960', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1320969221462556672', '1320969145759563776', '451002662209589248', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1320969221462556673', '1320969145759563776', '451003242072117248', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1320969221462556674', '1320969145759563776', '1305875436139446272', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778112', '1309851245195821056', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778113', '1309851245195821056', '1322085079861690368', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778114', '1309851245195821056', '1322085393021009920', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778115', '1309851245195821056', '1322085270392143872', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778116', '1309851245195821056', '1322085497798918144', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778117', '1309851245195821056', '1322085659766161408', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778118', '1309851245195821056', '3', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778119', '1309851245195821056', '1310209696916832256', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778120', '1309851245195821056', '1310209900478988288', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778121', '1309851245195821056', '1310210054728712192', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778122', '1309851245195821056', '442359447487123456', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778123', '1309851245195821056', '1310211965188046848', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778124', '1309851245195821056', '4', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778125', '1309851245195821056', '1310226416867999744', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778126', '1309851245195821056', '1310226976593674240', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778127', '1309851245195821056', '1310227130998587392', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778128', '1309851245195821056', '1310227300935008256', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778129', '1309851245195821056', '1315584471046553600', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778130', '1309851245195821056', '1316558444790022144', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778131', '1309851245195821056', '1316558556102656000', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778132', '1309851245195821056', '1317555660455411712', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778133', '1309851245195821056', '1316558685442408448', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778134', '1309851245195821056', '1304387665067507712', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778135', '1309851245195821056', '1310405161587310592', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778136', '1309851245195821056', '1310402491631796224', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778137', '1309851245195821056', '1310404584291696640', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778138', '1309851245195821056', '1310404705934901248', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778139', '1309851245195821056', '1310402688881524736', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778140', '1309851245195821056', '1310402817776680960', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778141', '1309851245195821056', '1310403004406431744', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778142', '1309851245195821056', '1310404831407505408', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778143', '1309851245195821056', '1310404999599095808', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778144', '1309851245195821056', '1304793451996381184', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778145', '1309851245195821056', '1310243862937075712', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778146', '1309851245195821056', '1310244103824343040', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778147', '1309851245195821056', '1310244248884346880', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778148', '1309851245195821056', '1307299332784914432', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778149', '1309851245195821056', '1310238229588344832', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778150', '1309851245195821056', '1310238417082122240', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778151', '1309851245195821056', '1310238574355939328', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778152', '1309851245195821056', '1310238700705153024', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778153', '1309851245195821056', '1349279791521464320', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778154', '1309851245195821056', '1349637786285637632', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778155', '1309851245195821056', '1349638479767666688', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778156', '1309851245195821056', '1349636919478190080', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778157', '1309851245195821056', '1349636574442160128', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778158', '1309851245195821056', '1355962888132493312', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778159', '1309851245195821056', '694203021537574912', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778160', '1309851245195821056', '1330865171429588992', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778161', '1309851245195821056', '1348562759603716096', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778162', '1309851245195821056', '442650770626711552', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778163', '1309851245195821056', '1310397832091402240', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778164', '1309851245195821056', '1310390699333517312', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778165', '1309851245195821056', '1310390994826428416', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778166', '1309851245195821056', '1310391095670079488', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778167', '1309851245195821056', '1310391707069579264', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778168', '1309851245195821056', '1310398020692475904', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778169', '1309851245195821056', '1310398158974484480', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778170', '1309851245195821056', '442651158935375872', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778171', '1309851245195821056', '1310395250908332032', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778172', '1309851245195821056', '450300705362808832', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778173', '1309851245195821056', '1310232350285627392', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778174', '1309851245195821056', '1310232462562951168', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778175', '1309851245195821056', '1349016358033031168', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778176', '1309851245195821056', '442417411065516032', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778177', '1309851245195821056', '442418188639145984', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778178', '1309851245195821056', '1302180351979814912', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778179', '1309851245195821056', '694203311615639552', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778180', '1309851245195821056', '1307562196556840960', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778181', '1309851245195821056', '1307562519451140096', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778182', '1309851245195821056', '1318229908526202880', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778183', '1309851245195821056', '1318230013262168064', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778184', '1309851245195821056', '1318230265385975808', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1355962953458778185', '1309851245195821056', '1308571483794046976', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712160', '1313761100243664896', '1304793451996381184', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712164', '1313761100243664896', '1307299332784914432', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712165', '1313761100243664896', '1310238229588344832', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712169', '1313761100243664896', '1349279791521464320', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712174', '1313761100243664896', '1355962888132493312', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712176', '1313761100243664896', '694203021537574912', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712177', '1313761100243664896', '1330865171429588992', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712178', '1313761100243664896', '442650770626711552', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712179', '1313761100243664896', '442651158935375872', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712180', '1313761100243664896', '450300705362808832', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712181', '1313761100243664896', '1349016358033031168', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712183', '1313761100243664896', '442418188639145984', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712185', '1313761100243664896', '694203311615639552', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712186', '1313761100243664896', '1307562196556840960', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712187', '1313761100243664896', '1307562519451140096', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('1370974927745712191', '1313761100243664896', '1308571483794046976', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('442062615250866176', '693913251020275712', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('442062615250866177', '693913251020275712', '2', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('442062615250866178', '693913251020275712', '3', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('442062615250866179', '693913251020275712', '4', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbce264cea55b7e65e3672', '61fa655795480e7687805640', '1', 'admin', '2022-02-03 20:44:22', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbce264cea55b7e65e3673', '61fa655795480e7687805640', '1322085079861690368', 'admin', '2022-02-03 20:44:22', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbce264cea55b7e65e3674', '61fa655795480e7687805640', '1322085270392143872', 'admin', '2022-02-03 20:44:22', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbcf5e4cea55b7e65e367a', '61fa655795480e7687805640', '1322085393021009920', 'admin', '2022-02-03 20:49:34', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbcf5e4cea55b7e65e367b', '61fa655795480e7687805640', '1322085497798918144', 'admin', '2022-02-03 20:49:34', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbcffa4ceaae530e8475ea', '61fa655795480e7687805640', '1322085659766161408', 'admin', '2022-02-03 20:52:10', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbd0e84ceaae530e8475eb', '61fa652e95480e768780563f', '1', 'admin', '2022-02-03 20:56:08', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbd0e84ceaae530e8475ec', '61fa652e95480e768780563f', '1322085079861690368', 'admin', '2022-02-03 20:56:08', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbd0e84ceaae530e8475ed', '61fa652e95480e768780563f', '1322085270392143872', 'admin', '2022-02-03 20:56:08', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbd0e84ceaae530e8475ee', '61fa652e95480e768780563f', '1322085393021009920', 'admin', '2022-02-03 20:56:08', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbd0e84ceaae530e8475ef', '61fa652e95480e768780563f', '1322085497798918144', 'admin', '2022-02-03 20:56:08', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbd0e84ceaae530e8475f0', '61fa652e95480e768780563f', '1322085659766161408', 'admin', '2022-02-03 20:56:08', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbd0ef4ceaae530e8475f1', '61fa652e95480e768780563f', '3', 'admin', '2022-02-03 20:56:15', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbd0ef4ceaae530e8475f2', '61fa652e95480e768780563f', '1310209696916832256', 'admin', '2022-02-03 20:56:15', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbd0ef4ceaae530e8475f3', '61fa652e95480e768780563f', '1310209900478988288', 'admin', '2022-02-03 20:56:15', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbd0ef4ceaae530e8475f4', '61fa652e95480e768780563f', '1310210054728712192', 'admin', '2022-02-03 20:56:15', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbd0ef4ceaae530e8475f5', '61fa652e95480e768780563f', '1310211965188046848', 'admin', '2022-02-03 20:56:15', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('61fbd0ef4ceaae530e8475f6', '61fa652e95480e768780563f', '442359447487123456', 'admin', '2022-02-03 20:56:15', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cb5', '1313761100243664896', '620370804cea44ea3ed88c9f', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cb6', '1313761100243664896', '620374ab4cea44ea3ed88ca0', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cb7', '1313761100243664896', '620376854cea44ea3ed88ca1', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cb8', '1313761100243664896', '620376c54cea44ea3ed88ca2', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cb9', '1313761100243664896', '620376e94cea44ea3ed88ca3', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cba', '1313761100243664896', '620377364cea44ea3ed88ca4', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cbb', '1313761100243664896', '620377654cea44ea3ed88ca5', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cbc', '1313761100243664896', '620377864cea44ea3ed88ca6', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cbd', '1313761100243664896', '620379514cea44ea3ed88ca7', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cbe', '1313761100243664896', '620379ad4cea44ea3ed88ca8', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cbf', '1313761100243664896', '620379ce4cea44ea3ed88ca9', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cc0', '1313761100243664896', '620379f04cea44ea3ed88caa', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cc1', '1313761100243664896', '62037a0d4cea44ea3ed88cab', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cc2', '1313761100243664896', '62037a2b4cea44ea3ed88cac', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cc3', '1313761100243664896', '62037a5b4cea44ea3ed88cad', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cc4', '1313761100243664896', '62037a764cea44ea3ed88cae', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cc5', '1313761100243664896', '62037a994cea44ea3ed88caf', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cc6', '1313761100243664896', '62037bcd4cea44ea3ed88cb0', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cc7', '1313761100243664896', '62037bec4cea44ea3ed88cb1', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cc8', '1313761100243664896', '62037c064cea44ea3ed88cb2', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cc9', '1313761100243664896', '62037c294cea44ea3ed88cb3', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
INSERT INTO `sys_role_power` VALUES ('62037c704cea44ea3ed88cca', '1313761100243664896', '62037c634cea44ea3ed88cb4', 'admin', '2022-02-09 16:33:53', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` varchar(32) NOT NULL COMMENT '编号',
  `username` char(20) DEFAULT NULL COMMENT '账户',
  `password` varchar(256) DEFAULT NULL COMMENT '密码',
  `salt` char(10) DEFAULT NULL COMMENT '姓名',
  `status` char(1) DEFAULT NULL COMMENT '状态',
  `real_name` varchar(20) DEFAULT NULL COMMENT '姓名',
  `email` char(20) DEFAULT NULL COMMENT '邮箱',
  `avatar` varchar(30) DEFAULT NULL COMMENT '头像',
  `sex` char(1) DEFAULT NULL COMMENT '性别',
  `phone` char(11) DEFAULT NULL COMMENT '电话',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` char(1) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` char(1) DEFAULT NULL COMMENT '修改人',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `enable` char(1) DEFAULT NULL COMMENT '是否启用',
  `login` char(1) DEFAULT NULL COMMENT '是否登录',
  `dept_id` char(19) DEFAULT NULL COMMENT '部门编号',
  `last_time` datetime DEFAULT NULL COMMENT '最后一次登录时间',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('1306230031168569344', 'feng', '$shiro1$SHA-256$15$wodk3nTYZ37L4GD3nr1M5A==$QbnNrJX+bMmfU/YZrFUPdjF2ONrdvYEnSpmocuJzkyM=', NULL, '0', '风筝', 'feng@gmail.com', NULL, '0', '15553726531', '2000-02-09 00:00:00', NULL, NULL, NULL, '被岁月镂空，亦受其雕琢', '0', NULL, '9', NULL);
INSERT INTO `sys_user` VALUES ('1309861917694623744', 'admin', '$shiro1$SHA-256$15$n+4jNzqF56wVawG6unRDug==$UXM+O2F501lAFJETVYPfRrJxOxjBZ4devmAcH3AQaoc=', NULL, '1', '管理', 'Jmys1992@qq.com', '/upload/default-avatar.jpeg', '1', '15553726539', '2020-09-26 22:26:32', NULL, NULL, NULL, '被岁月镂空，亦受其雕琢', '1', NULL, '9', '2021-04-28 01:16:39');
INSERT INTO `sys_user` VALUES ('1310409555649232897', 'ruhua', '$shiro1$SHA-256$15$wodk3nTYZ37L4GD3nr1M5A==$QbnNrJX+bMmfU/YZrFUPdjF2ONrdvYEnSpmocuJzkyM=', NULL, '1', '如花', 'ruhua@gmail.com', NULL, '0', '15553726531', '2020-09-28 10:42:39', NULL, NULL, NULL, NULL, '1', NULL, '9', NULL);
INSERT INTO `sys_user` VALUES ('1349016976730619905', 'mwj', '$shiro1$SHA-256$15$wodk3nTYZ37L4GD3nr1M5A==$QbnNrJX+bMmfU/YZrFUPdjF2ONrdvYEnSpmocuJzkyM=', NULL, '1', 'jingfu li', '2102409310@qq.com', NULL, '1', '15656428391', '2021-01-12 23:34:45', NULL, NULL, NULL, NULL, '1', NULL, '1377824449830584320', '2021-01-12 23:35:12');
INSERT INTO `sys_user` VALUES ('1349021166525743105', 'xiana', '$shiro1$SHA-256$15$wodk3nTYZ37L4GD3nr1M5A==$QbnNrJX+bMmfU/YZrFUPdjF2ONrdvYEnSpmocuJzkyM=', NULL, '1', '夏娜', 'xiana@gmail.com', NULL, '0', '15553726531', '2021-01-12 23:51:24', NULL, NULL, NULL, NULL, '1', NULL, '1377825171905183744', NULL);
INSERT INTO `sys_user` VALUES ('1355966975355912193', 'sanman', '$shiro1$SHA-256$15$wodk3nTYZ37L4GD3nr1M5A==$QbnNrJX+bMmfU/YZrFUPdjF2ONrdvYEnSpmocuJzkyM=', NULL, '1', '散漫', 'sanman@gmail.com', NULL, '0', '15553726531', '2021-02-01 03:51:34', NULL, NULL, NULL, NULL, '1', NULL, '1377824449830584320', NULL);
INSERT INTO `sys_user` VALUES ('1355967204012589057', 'langhua', '$shiro1$SHA-256$15$wodk3nTYZ37L4GD3nr1M5A==$QbnNrJX+bMmfU/YZrFUPdjF2ONrdvYEnSpmocuJzkyM=', NULL, '0', '浪花', 'langhua@gmail.com', NULL, '0', '15553726531', '2021-02-01 03:52:29', NULL, NULL, NULL, NULL, '1', NULL, '9', NULL);
INSERT INTO `sys_user` VALUES ('1355967579994193921', 'zidian', '$shiro1$SHA-256$15$wodk3nTYZ37L4GD3nr1M5A==$QbnNrJX+bMmfU/YZrFUPdjF2ONrdvYEnSpmocuJzkyM=', NULL, '0', '字典', 'zidian', NULL, '0', '15553726531', '2021-02-01 03:53:58', NULL, NULL, NULL, NULL, '1', NULL, '9', NULL);
INSERT INTO `sys_user` VALUES ('1370973608502886401', 'duanlang', '$shiro1$SHA-256$15$wodk3nTYZ37L4GD3nr1M5A==$QbnNrJX+bMmfU/YZrFUPdjF2ONrdvYEnSpmocuJzkyM=', NULL, '0', '断浪', 'duanlang@gmail.com', NULL, '0', '15553726531', '2021-03-14 13:42:34', NULL, NULL, NULL, NULL, '1', NULL, '9', '2021-03-14 13:47:28');
INSERT INTO `sys_user` VALUES ('61f4a47f4cea117b06a04190', 'jingfu', '$shiro1$SHA-256$15$ohaK1oTM3zRiaH3OTJ5Ckg==$UYJkaEMnj+da3VgccHW4rGl+XZRoJqfq4qAMk7C1KTs=', NULL, '0', 'jingfu', '2102409310@qq.com', NULL, '1', '15656428391', '2022-01-29 10:20:48', NULL, '2022-01-29 10:20:48', NULL, NULL, '1', NULL, NULL, NULL);
INSERT INTO `sys_user` VALUES ('61f4a47f4cea117b06a04191', 'jingfu', '$shiro1$SHA-256$15$7ht52gE8y5IqfPBSA0AcDQ==$Utsy+8aOrlY7qlZLr9ItdhyJYQuiNjwk7F/yJ2TwhpY=', NULL, '0', 'jingfu', '2102409310@qq.com', NULL, '1', '15656428391', '2022-01-29 10:20:48', NULL, '2022-01-29 10:20:48', NULL, NULL, '1', NULL, NULL, NULL);
INSERT INTO `sys_user` VALUES ('61f75a194cea04679f108252', 'admin2', '$shiro1$SHA-256$15$v1zw45j00jIyaHVPF3jWkw==$SwvllfkR4vIkMqh/UMfoBB6da9vkzSYeVr/2pKcjT7w=', NULL, '1', 'jingfu li', '2102409310@qq.com', NULL, '1', '15656428391', '2022-01-31 11:40:10', NULL, '2022-01-31 11:40:10', NULL, NULL, '1', NULL, '1377824449830584320', NULL);
INSERT INTO `sys_user` VALUES ('61f75a194cea04679f108253', 'admin2', '$shiro1$SHA-256$15$NlYK+NnEUmQv8QA/acRtDA==$0LV4U5N+vPC7V+zaSUFdthVxxsDSo/AoTPnzx322CMw=', NULL, '1', 'jingfu li', '2102409310@qq.com', NULL, '1', '15656428391', '2022-01-31 11:40:10', NULL, '2022-01-31 11:40:10', NULL, NULL, '1', NULL, NULL, NULL);
INSERT INTO `sys_user` VALUES ('61f75a254cea04679f108255', 'admin3', '$shiro1$SHA-256$15$ZEEiGr4sztfKkBFzIkqe7A==$wjQpMKL1B4wm3W6OGws40w9WE7E6C0CqONNeTZc5IPI=', NULL, '0', 'jingfu li', '2102409310@qq.com', NULL, '1', '15656428391', '2022-01-31 11:40:22', NULL, '2022-01-31 11:40:22', NULL, NULL, '1', NULL, NULL, NULL);
INSERT INTO `sys_user` VALUES ('61f75a354cea04679f108257', 'admin4', '$shiro1$SHA-256$15$seX9m8KjGUyKUht+hjfdRA==$WzaaOHmapcQDLMunlVWsTwoGEJKOMXqUGQnHGRfgfo4=', NULL, '1', 'jingfu li', '2102409310@qq.com', NULL, '1', '15656428391', '2022-01-31 11:40:37', NULL, '2022-01-31 11:40:37', NULL, NULL, '1', NULL, '10', NULL);
INSERT INTO `sys_user` VALUES ('61f75a434cea04679f108259', 'admin45', '$shiro1$SHA-256$15$MPXG8i5Xm27mfgu8URORog==$l6HrZfigfQr4hsjoxU3kiDLipV9jVs9nXTdO96jAC4U=', NULL, '0', 'jingfu li', '2102409310@qq.com', NULL, '1', '15656428391', '2022-01-31 11:40:52', NULL, '2022-01-31 11:40:52', NULL, NULL, '1', NULL, NULL, NULL);
INSERT INTO `sys_user` VALUES ('61f75a514cea04679f10825b', '334dd', '$shiro1$SHA-256$15$5lFsHgddeAThnuy/02REng==$Sf3+2d+5hVZLp3RRwidSg8vDzLOoK+ZMZG7caxotE/w=', NULL, '1', 'jingfu li', '2102409310@qq.com', NULL, '1', '15656428391', '2022-01-31 11:41:06', NULL, '2022-01-31 11:41:06', NULL, NULL, '1', NULL, '1377824449830584320', NULL);
INSERT INTO `sys_user` VALUES ('61f75a624cea04679f10825d', 'ad33min', '$shiro1$SHA-256$15$dA6JyxFOQQZrtvHRTNBisw==$oXYUPq4Rhdz+SU99Og614cyEVnKmkFfQvjUOBWFch+A=', NULL, '1', 'jingfu li', '2102409310@qq.com', NULL, '1', '15656428391', '2022-01-31 11:41:23', NULL, '2022-01-31 11:41:23', NULL, NULL, '1', NULL, '1377824449830584320', NULL);
INSERT INTO `sys_user` VALUES ('62025dea4ceae60079fa8ef5', 'admin333', '$shiro1$SHA-256$15$B1NDdViUO02jPVNnfem0Ew==$zScEDghQZVOfcmFFINT31ypeJi2SvzlZRXwyCWAmj2Q=', NULL, '1', '333', '2102409310@qq.com', NULL, '1', '15656428391', '2022-02-08 20:11:22', NULL, '2022-02-08 20:11:22', NULL, NULL, '1', NULL, '1377824449830584320', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` varchar(32) NOT NULL COMMENT '标识',
  `user_id` varchar(32) DEFAULT NULL COMMENT '用户编号',
  `role_id` varchar(32) DEFAULT NULL COMMENT '角色编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES ('1302196622322565120', '1302196622007992320', '1');
INSERT INTO `sys_user_role` VALUES ('1304443027040763904', '1304443026482921472', '1');
INSERT INTO `sys_user_role` VALUES ('1304443027044958208', '1304443026482921472', '2');
INSERT INTO `sys_user_role` VALUES ('1304443027044958209', '1304443026482921472', '3');
INSERT INTO `sys_user_role` VALUES ('1304443307404820480', '1304443306888921088', '1');
INSERT INTO `sys_user_role` VALUES ('1304443307404820481', '1304443306888921088', '2');
INSERT INTO `sys_user_role` VALUES ('1305359805342285824', '1305359804906078208', '');
INSERT INTO `sys_user_role` VALUES ('1305359807724650496', '1305359807296831488', '');
INSERT INTO `sys_user_role` VALUES ('1305390235135246336', '1305390234694844416', '');
INSERT INTO `sys_user_role` VALUES ('1306229860422647808', '1306229859755753472', '1');
INSERT INTO `sys_user_role` VALUES ('1306229892144168960', '1306229891624075264', '1');
INSERT INTO `sys_user_role` VALUES ('1306243520893288448', '1306243520482246656', '');
INSERT INTO `sys_user_role` VALUES ('1308074663896678400', '1308074663313670144', '1');
INSERT INTO `sys_user_role` VALUES ('1308074663896678401', '1308074663313670144', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1308074663896678402', '1308074663313670144', '2');
INSERT INTO `sys_user_role` VALUES ('1308075167091523584', '1308075166433017856', '1');
INSERT INTO `sys_user_role` VALUES ('1308075167091523585', '1308075166433017856', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1308075241188098048', '1308074939114323968', '1');
INSERT INTO `sys_user_role` VALUES ('1308075241188098049', '1308074939114323968', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1308075407685189632', '1308075407114764288', '1');
INSERT INTO `sys_user_role` VALUES ('1308075407685189633', '1308075407114764288', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1308075638158000128', '1308075637621129216', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1308328954523811840', '1308328954045661184', '1');
INSERT INTO `sys_user_role` VALUES ('1308328954523811841', '1308328954045661184', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1308328954523811842', '1308328954045661184', '2');
INSERT INTO `sys_user_role` VALUES ('1308571264494862336', '1308076162903179264', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1309445423668133888', '1309444883659882496', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1309445423668133889', '1309444883659882496', '1309121036125470720');
INSERT INTO `sys_user_role` VALUES ('1309445423668133890', '1309444883659882496', '2');
INSERT INTO `sys_user_role` VALUES ('1309752526945386496', '1', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1309752526945386497', '1', '1309121036125470720');
INSERT INTO `sys_user_role` VALUES ('1309752526945386498', '1', '2');
INSERT INTO `sys_user_role` VALUES ('1309860016655695872', '1309860016043327488', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1309860554432577536', '1309860553891512320', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1309861324494209024', '1309861323898617856', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1309861325593116672', '1309861324909445120', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1310080380040118272', '1310080379331280896', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1310080380589572096', '1310080379935260672', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1310080718918909952', '1310080718256209920', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1310080719917154304', '1310080719208316928', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1310082314557980672', '1310082313954000896', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1310082315195514880', '1310082314545397760', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1310083089153654784', '1310083088511926272', '1309121036125470720');
INSERT INTO `sys_user_role` VALUES ('1310083089828937728', '1310083089216569344', '1309121036125470720');
INSERT INTO `sys_user_role` VALUES ('1310083324709961728', '1310083324110176256', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1310208453033066496', '1310208452424892416', '1309121036125470720');
INSERT INTO `sys_user_role` VALUES ('1310209026096627712', '1310209025576534016', '1306230258952830976');
INSERT INTO `sys_user_role` VALUES ('1310209026096627713', '1310209025576534016', '1309121036125470720');
INSERT INTO `sys_user_role` VALUES ('1310381721815875584', '1306229381332467712', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1310424875067768832', '1310421836906889217', '1310421428759166976');
INSERT INTO `sys_user_role` VALUES ('1314015448013996032', '1304491590080790528', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1314410103465574400', '1314410059245027329', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1314416691479838720', '1314416690875858945', '');
INSERT INTO `sys_user_role` VALUES ('1316251185065230336', '1306230031168569344', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1316275764227735552', '1316275763711836161', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1316275764227735553', '1316275763711836161', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('1316275899439513600', '1315827004456566785', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1316275899439513601', '1315827004456566785', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('1316275930657718272', '1315829324519047169', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1316276059032780800', '1310409555649232897', '');
INSERT INTO `sys_user_role` VALUES ('1316410619078901760', '1306229606205882368', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1316410619078901761', '1306229606205882368', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('1316410619078901762', '1306229606205882368', '1316407534105395200');
INSERT INTO `sys_user_role` VALUES ('1316410619078901763', '1306229606205882368', '1316408008376320000');
INSERT INTO `sys_user_role` VALUES ('1318205966671413248', '1318205965996130305', '');
INSERT INTO `sys_user_role` VALUES ('1320899195875360768', '1320899195225243649', '');
INSERT INTO `sys_user_role` VALUES ('1329795580615983104', '1329795579919728641', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1329795580615983105', '1329795579919728641', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('1329795614484987904', '1329795613730013185', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1329795688124383232', '1329795687465877505', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('1329795704863850496', '1329795703882383361', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('1329795716930863104', '1329795716255580161', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('1329795741211688960', '1329795740536406017', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1349021167326855168', '1349021166525743105', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1349021167326855169', '1349021166525743105', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('1355967256000987136', '1355966975355912193', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1355967256000987137', '1355966975355912193', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('1355967330718318592', '1355967204012589057', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1355967330718318593', '1355967204012589057', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('1355967580686254080', '1355967579994193921', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1355967580686254081', '1355967579994193921', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('1360858458609418240', '1309861917694623744', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('1360858458609418241', '1309861917694623744', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('1370973609278832640', '1370973608502886401', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('442110794142978048', NULL, '1');
INSERT INTO `sys_user_role` VALUES ('442110794142978049', NULL, '2');
INSERT INTO `sys_user_role` VALUES ('442110794142978050', NULL, '3');
INSERT INTO `sys_user_role` VALUES ('442114944884936704', '442114944884936704', '1');
INSERT INTO `sys_user_role` VALUES ('442114944884936705', '442114944884936704', '2');
INSERT INTO `sys_user_role` VALUES ('442114944884936706', '442114944884936704', '3');
INSERT INTO `sys_user_role` VALUES ('442114944884936707', '442114944884936704', '693913251020275712');
INSERT INTO `sys_user_role` VALUES ('442114944884936708', '442114944884936704', '693949793801601024');
INSERT INTO `sys_user_role` VALUES ('442114944884936709', '442114944884936704', '694106517393113088');
INSERT INTO `sys_user_role` VALUES ('442127724396548096', '3', '1');
INSERT INTO `sys_user_role` VALUES ('442127724396548097', '3', '2');
INSERT INTO `sys_user_role` VALUES ('442127724396548098', '3', '3');
INSERT INTO `sys_user_role` VALUES ('445004989551742976', '442492965651353600', '1');
INSERT INTO `sys_user_role` VALUES ('445004989551742977', '442492965651353600', '2');
INSERT INTO `sys_user_role` VALUES ('445005010271604736', '444226209941950464', '1');
INSERT INTO `sys_user_role` VALUES ('445005010271604737', '444226209941950464', '2');
INSERT INTO `sys_user_role` VALUES ('445005010271604738', '444226209941950464', '3');
INSERT INTO `sys_user_role` VALUES ('447196043407396864', '447196042723725312', '1');
INSERT INTO `sys_user_role` VALUES ('447196043407396865', '447196042723725312', '2');
INSERT INTO `sys_user_role` VALUES ('447197132043194368', '447197131518906368', '1');
INSERT INTO `sys_user_role` VALUES ('447197773046091776', '447197772274339840', '1');
INSERT INTO `sys_user_role` VALUES ('447200144400715776', '447199996320813056', '1');
INSERT INTO `sys_user_role` VALUES ('447200144400715777', '447199996320813056', '2');
INSERT INTO `sys_user_role` VALUES ('449248198469488640', '449248198058446848', '3');
INSERT INTO `sys_user_role` VALUES ('463926002653990912', '463926002318446592', '3');
INSERT INTO `sys_user_role` VALUES ('463926371165540352', '442488661347536896', '3');
INSERT INTO `sys_user_role` VALUES ('61f4a2764cea8dd984db61e2', '61f4a2764cea8dd984db61e3', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('61f4a47f4cea117b06a0418e', '61f4a47f4cea117b06a04190', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('61f4a47f4cea117b06a0418f', '61f4a47f4cea117b06a04191', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('61f4cb2d4ceaac8028800947', '61f4cb2d4ceaac8028800948', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('61f697ef4cea8a5cf353be03', '1349016976730619905', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('61f697ef4cea8a5cf353be04', '1349016976730619905', '1356112133691015168');
INSERT INTO `sys_user_role` VALUES ('61f75a194cea04679f108250', '61f75a194cea04679f108253', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('61f75a194cea04679f108251', '61f75a194cea04679f108252', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('61f75a254cea04679f108254', '61f75a254cea04679f108255', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('61f75a354cea04679f108256', '61f75a354cea04679f108257', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('61f75a434cea04679f108258', '61f75a434cea04679f108259', '1313761100243664896');
INSERT INTO `sys_user_role` VALUES ('61f75a514cea04679f10825a', '61f75a514cea04679f10825b', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('61f75a624cea04679f10825c', '61f75a624cea04679f10825d', '1309851245195821056');
INSERT INTO `sys_user_role` VALUES ('62025dea4ceae60079fa8ef4', '62025dea4ceae60079fa8ef5', '61fa649395480e768780563c');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
